﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MusicOnSpace
{
    public class Singer
    {
        public string singId { get; set; }
        public string singName { get; set; }
        public string singSongs { get; set; }
        public string singAge { get; set; }
        public string singBirth { get; set; }
        public string singDescribe { get; set; }

        List<Singer> SingerList = new List<Singer>();
        dataProvider dp = new dataProvider();

        public void InsertSinger(string id, string name, string birth, string death, string describe, string album)
        {
            string command = "Insert into Singer (singId, singName, singBirth, singDeath, singDescribe, albumName) values (" + id + "," + name + "," + birth + "," + death + "," + describe + ","+ album +")";

            dp.ExeCuteNonQuery(command);
        }

        public void DeleteSinger(string id)
        {
            string command = "";
            dp.ExeCuteNonQuery(command);
        }

        public void SingerSearch(string name)
        {
            string command = "Select * from Singer where name like 'N" + name + "'";
            dp.ExeCuteNonQuery(command);
        }

        public void GetSinger()
        {

        }

        public List<Singer> AddSinger()
        {
            //SqlCommand cmd = new SqlCommand ("Insert into Singerber (
            return SingerList;
        }
    }
}